package org.e_gold.util;

public interface SQL {

	String UPDATE_ALL_SETTLED_CONTRACT_RUNNING_TO_FALSE = "UPDATE settled_contract SET running = false;";
	String UPDATE_SETTED_CONTRACT_RUNNING_TO_FALSE = "UPDATE settled_contract SET running = false WHERE id = :id_settled_contract";
	String UPDATE_ALL_CONTRACT_QUALIFY_TO_FALSE = "UPDATE contract SET qualify = false;";
	String UPDATE_CONTRACT_QUALIFY_TO_FALSE = "UPDATE contract SET qualify = false WHERE id IN (idList);";
	//for config setting
	String UPDATE_ALL_COUNTRY_TO_FALSE = "UPDATE country SET status = false;";
	String UPDATE_ALL_LEAGUE_TO_FALSE = "UPDATE league SET status = false;";

	String UPDATE_COUNTRY_STATUS_TO_TRUE = "UPDATE country SET status = true WHERE id IN (idList)";
	String UPDATE_LEAGUE_STATUS_TO_TRUE = "UPDATE league SET status = true WHERE id IN (idList)";
}
